package cn.rui.config;

import com.baomidou.mybatisplus.core.injector.ISqlInjector;
import com.baomidou.mybatisplus.extension.injector.LogicSqlInjector;
import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PerformanceInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Profile;
import org.springframework.transaction.annotation.EnableTransactionManagement;

/**
 * @author 徽州大都督
 * @date 2020/7/13
 */

@EnableTransactionManagement //自动管理事务,默认开启
@Configuration  //配置类
public class MybatisConfig {

    //注册乐观锁插件
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor(){
        return new OptimisticLockerInterceptor ();
    }


    //分页配置
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();

    }

    //逻辑删除组件
    @Bean
    public ISqlInjector sqlInjector(){
        return new LogicSqlInjector ();
    }

    //SQL执行效率插件
    @Bean
    @Profile ({"dev","test"})  //设置dev  test 环境开启，保证我们的效率
    public PerformanceInterceptor performanceInterceptor(){
        PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor ();

        performanceInterceptor.setMaxTime (100);  //设置sql执行的最大时间，如果超过就不执行,100毫秒
        performanceInterceptor.setFormat (true);  //sql格式化
        return performanceInterceptor;
    }
}
